Pandas_Profiling

Dataset statistics

Number of variables	20
Number of observations	11933
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.8 MiB
Average record size in memory	160.0 B

Variable types

Numeric	20

Alerts

`weight2` is highly overall correlated with `htin4` and 3 other fields	High correlation
`height3` is highly overall correlated with `htin4` and 1 other fields	High correlation
`alcday5` is highly overall correlated with `x.drnkwek`	High correlation
`htin4` is highly overall correlated with `weight2` and 2 other fields	High correlation
`wtkg3` is highly overall correlated with `weight2` and 1 other fields	High correlation
`x.bmi5` is highly overall correlated with `weight2` and 1 other fields	High correlation
`htm4` is highly overall correlated with `weight2` and 2 other fields	High correlation
`x.drnkwek` is highly overall correlated with `alcday5` and 1 other fields	High correlation
`drocdy3.` is highly overall correlated with `x.drnkwek`	High correlation
`x.llcpwt2` is highly overall correlated with `x.llcpwt` and 2 other fields	High correlation
`x.llcpwt` is highly overall correlated with `x.llcpwt2` and 2 other fields	High correlation
`x.wt2rake` is highly overall correlated with `x.llcpwt2` and 2 other fields	High correlation
`x.strwt` is highly overall correlated with `x.llcpwt2` and 2 other fields	High correlation
`physhlth` is highly overall correlated with `menthlth`	High correlation
`menthlth` is highly overall correlated with `physhlth`	High correlation
`x.drnkwek` has 5546 (46.5%) zeros	Zeros
`drocdy3.` has 5546 (46.5%) zeros	Zeros

Reproduction

Analysis started	2022-12-09 00:37:41.474174
Analysis finished	2022-12-09 00:38:40.964973
Duration	59.49 seconds
Software version	pandas-profiling vv3.5.0
Download configuration	config.json

weight2
Real number (ℝ)

Distinct	255
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	180.39697

Minimum	50
Maximum	390
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	93.4 KiB

Quantile statistics

Minimum	50
5-th percentile	120
Q1	150
median	180
Q3	200
95-th percentile	260
Maximum	390
Range	340
Interquartile range (IQR)	50

Descriptive statistics

Standard deviation	43.004842
Coefficient of variation (CV)	0.23839005
Kurtosis	1.4302054
Mean	180.39697
Median Absolute Deviation (MAD)	27
Skewness	0.87560842
Sum	2152677
Variance	1849.4164
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
180	1395	11.7%
200	535	4.5%
150	514	4.3%
160	493	4.1%
170	436	3.7%
140	376	3.2%
190	369	3.1%
175	310	2.6%
165	303	2.5%
130	292	2.4%
Other values (245)	6910	57.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
50	1	< 0.1%
51	1	< 0.1%
60	1	< 0.1%
70	3	< 0.1%
75	1	< 0.1%
77	1	< 0.1%
80	2	< 0.1%
85	6	0.1%
86	1	< 0.1%
87	1	< 0.1%

Value	Count	Frequency (%)
390	6	0.1%
386	1	< 0.1%
382	1	< 0.1%
380	5	< 0.1%
372	1	< 0.1%
371	1	< 0.1%
370	3	< 0.1%
365	1	< 0.1%
360	6	0.1%
358	1	< 0.1%

height3
Real number (ℝ)

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	506.1428

Minimum	500
Maximum	511
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	93.4 KiB

Quantile statistics

Minimum	500
5-th percentile	501
Q1	504
median	507
Q3	508
95-th percentile	511
Maximum	511
Range	11
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.7642702
Coefficient of variation (CV)	0.0054614432
Kurtosis	-0.48083327
Mean	506.1428
Median Absolute Deviation (MAD)	2
Skewness	-0.31990751
Sum	6039802
Variance	7.6411895
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
507	3479	29.2%
506	1050	8.8%
504	966	8.1%
505	922	7.7%
508	912	7.6%
503	846	7.1%
510	797	6.7%
509	786	6.6%
502	726	6.1%
511	678	5.7%
Other values (2)	771	6.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
500	384	3.2%
501	387	3.2%
502	726	6.1%
503	846	7.1%
504	966	8.1%
505	922	7.7%
506	1050	8.8%
507	3479	29.2%
508	912	7.6%
509	786	6.6%

Value	Count	Frequency (%)
511	678	5.7%
510	797	6.7%
509	786	6.6%
508	912	7.6%
507	3479	29.2%
506	1050	8.8%
505	922	7.7%
504	966	8.1%
503	846	7.1%
502	726	6.1%

children
Real number (ℝ)

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	65.810442

Minimum	1
Maximum	99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	93.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	5
median	88
Q3	88
95-th percentile	88
Maximum	99
Range	98
Interquartile range (IQR)	83

Descriptive statistics

Standard deviation	37.732501
Coefficient of variation (CV)	0.57335128
Kurtosis	-0.78437867
Mean	65.810442
Median Absolute Deviation (MAD)	0
Skewness	-1.1004611
Sum	785316
Variance	1423.7416
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
88	8768	73.5%
1	1239	10.4%
2	1141	9.6%
3	420	3.5%
4	179	1.5%
99	77	0.6%
5	71	0.6%
6	23	0.2%
7	7	0.1%
9	4	< 0.1%
Other values (2)	4	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1239	10.4%
2	1141	9.6%
3	420	3.5%
4	179	1.5%
5	71	0.6%
6	23	0.2%
7	7	0.1%
8	3	< 0.1%
9	4	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
99	77	0.6%
88	8768	73.5%
10	1	< 0.1%
9	4	< 0.1%
8	3	< 0.1%
7	7	0.1%
6	23	0.2%
5	71	0.6%
4	179	1.5%
3	420	3.5%

alcday5
Real number (ℝ)

Distinct	38
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	541.51094

Minimum	101
Maximum	999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	93.4 KiB

Quantile statistics

Minimum	101
5-th percentile	102
Q1	202
median	888
Q3	888
95-th percentile	888
Maximum	999
Range	898
Interquartile range (IQR)	686

Descriptive statistics

Standard deviation	356.64686
Coefficient of variation (CV)	0.65861432
Kurtosis	-1.9503956
Mean	541.51094
Median Absolute Deviation (MAD)	0
Skewness	-0.078043159
Sum	6461850
Variance	127196.98
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=38)

Value	Count	Frequency (%)
888	5982	50.1%
201	901	7.6%
202	646	5.4%
101	471	3.9%
102	435	3.6%
230	412	3.5%
203	361	3.0%
205	311	2.6%
204	307	2.6%
103	301	2.5%
Other values (28)	1806	15.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
101	471	3.9%
102	435	3.6%
103	301	2.5%
104	126	1.1%
105	145	1.2%
106	39	0.3%
107	204	1.7%
201	901	7.6%
202	646	5.4%
203	361	3.0%

Value	Count	Frequency (%)
999	44	0.4%
888	5982	50.1%
777	99	0.8%
230	412	3.5%
229	14	0.1%
228	27	0.2%
227	6	0.1%
226	5	< 0.1%
225	78	0.7%
224	8	0.1%

x.psu
Real number (ℝ)

Distinct	7775
Distinct (%)	65.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.0180058 × 10⁹

Minimum	2.018 × 10⁹
Maximum	2.0180357 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	93.4 KiB

Quantile statistics

Minimum	2.018 × 10⁹
5-th percentile	2.0180004 × 10⁹
Q1	2.0180021 × 10⁹
median	2.0180043 × 10⁹
Q3	2.0180076 × 10⁹
95-th percentile	2.0180159 × 10⁹
Maximum	2.0180357 × 10⁹
Range	35720
Interquartile range (IQR)	5539

Descriptive statistics

Standard deviation	5695.2278
Coefficient of variation (CV)	2.8222059 × 10^-6
Kurtosis	7.3621435
Mean	2.0180058 × 10⁹
Median Absolute Deviation (MAD)	2535
Skewness	2.3828154
Sum	2.4080863 × 10¹³
Variance	32435620
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2018003506	8	0.1%
2018001343	8	0.1%
2018000983	6	0.1%
2018004994	6	0.1%
2018003451	6	0.1%
2018000065	6	0.1%
2018000102	6	0.1%
2018001290	6	0.1%
2018002705	6	0.1%
2018004047	6	0.1%
Other values (7765)	11869	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2018000001	1	< 0.1%
2018000002	4	< 0.1%
2018000003	3	< 0.1%
2018000004	1	< 0.1%
2018000005	4	< 0.1%
2018000006	2	< 0.1%
2018000007	4	< 0.1%
2018000008	1	< 0.1%
2018000009	4	< 0.1%
2018000010	2	< 0.1%

Value	Count	Frequency (%)
2018035721	1	< 0.1%
2018035620	1	< 0.1%
2018035563	1	< 0.1%
2018035477	1	< 0.1%
2018035474	1	< 0.1%
2018035409	1	< 0.1%
2018035373	1	< 0.1%
2018035338	1	< 0.1%
2018035305	1	< 0.1%
2018035267	1	< 0.1%

physhlth
Real number (ℝ)

Distinct	32
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	60.782955

Minimum	1
Maximum	99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	93.4 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	15
median	88
Q3	88
95-th percentile	88
Maximum	99
Range	98
Interquartile range (IQR)	73

Descriptive statistics

Standard deviation	36.945103
Coefficient of variation (CV)	0.60782013
Kurtosis	-1.4091911
Mean	60.782955
Median Absolute Deviation (MAD)	0
Skewness	-0.69240404
Sum	725323
Variance	1364.9407
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=32)

Value	Count	Frequency (%)
88	7424	62.2%
30	962	8.1%
2	649	5.4%
1	498	4.2%
3	373	3.1%
5	333	2.8%
10	244	2.0%
15	226	1.9%
77	224	1.9%
7	223	1.9%
Other values (22)	777	6.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	498	4.2%
2	649	5.4%
3	373	3.1%
4	194	1.6%
5	333	2.8%
6	63	0.5%
7	223	1.9%
8	34	0.3%
9	10	0.1%
10	244	2.0%

Value	Count	Frequency (%)
99	42	0.4%
88	7424	62.2%
77	224	1.9%
30	962	8.1%
29	8	0.1%
28	22	0.2%
27	8	0.1%
26	1	< 0.1%
25	56	0.5%
24	1	< 0.1%

menthlth
Real number (ℝ)

Distinct	33
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	63.526439

Minimum	1
Maximum	99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	93.4 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	20
median	88
Q3	88
95-th percentile	88
Maximum	99
Range	98
Interquartile range (IQR)	68

Descriptive statistics

Standard deviation	36.210707
Coefficient of variation (CV)	0.57001002
Kurtosis	-1.1707878
Mean	63.526439
Median Absolute Deviation (MAD)	0
Skewness	-0.8576702
Sum	758061
Variance	1311.2153
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=33)

Value	Count	Frequency (%)
88	7948	66.6%
30	654	5.5%
2	586	4.9%
5	421	3.5%
1	348	2.9%
3	326	2.7%
10	307	2.6%
15	288	2.4%
7	190	1.6%
4	174	1.5%
Other values (23)	691	5.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	348	2.9%
2	586	4.9%
3	326	2.7%
4	174	1.5%
5	421	3.5%
6	48	0.4%
7	190	1.6%
8	42	0.4%
9	4	< 0.1%
10	307	2.6%

Value	Count	Frequency (%)
99	49	0.4%
88	7948	66.6%
77	150	1.3%
30	654	5.5%
29	4	< 0.1%
28	22	0.2%
27	10	0.1%
26	2	< 0.1%
25	58	0.5%
24	3	< 0.1%

sleptim1
Real number (ℝ)

Distinct	22
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.8349116

Minimum	1
Maximum	99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	93.4 KiB

Quantile statistics

Minimum	1
5-th percentile	5
Q1	6
median	7
Q3	8
95-th percentile	9
Maximum	99
Range	98
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	7.7235093
Coefficient of variation (CV)	0.9857813
Kurtosis	79.608776
Mean	7.8349116
Median Absolute Deviation (MAD)	1
Skewness	8.8168433
Sum	93494
Variance	59.652596
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=22)

Value	Count	Frequency (%)
7	3578	30.0%
8	3452	28.9%
6	2527	21.2%
5	788	6.6%
9	506	4.2%
4	343	2.9%
10	274	2.3%
77	126	1.1%
12	100	0.8%
3	100	0.8%
Other values (12)	139	1.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	36	0.3%
2	32	0.3%
3	100	0.8%
4	343	2.9%
5	788	6.6%
6	2527	21.2%
7	3578	30.0%
8	3452	28.9%
9	506	4.2%
10	274	2.3%

Value	Count	Frequency (%)
99	9	0.1%
77	126	1.1%
23	1	< 0.1%
20	3	< 0.1%
18	4	< 0.1%
17	2	< 0.1%
16	8	0.1%
15	12	0.1%
14	6	0.1%
13	2	< 0.1%

htin4
Real number (ℝ)

Distinct	33
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	66.951311

Minimum	48
Maximum	81
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	93.4 KiB

Quantile statistics

Minimum	48
5-th percentile	61
Q1	64
median	67
Q3	70
95-th percentile	74
Maximum	81
Range	33
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	4.0288175
Coefficient of variation (CV)	0.060175334
Kurtosis	-0.19693051
Mean	66.951311
Median Absolute Deviation (MAD)	3
Skewness	0.076357052
Sum	798930
Variance	16.23137
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=33)

Value	Count	Frequency (%)
67	1448	12.1%
66	1050	8.8%
64	966	8.1%
65	922	7.7%
68	912	7.6%
63	846	7.1%
72	817	6.8%
70	797	6.7%
69	786	6.6%
62	726	6.1%
Other values (23)	2663	22.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
48	5	< 0.1%
49	1	< 0.1%
50	2	< 0.1%
51	1	< 0.1%
53	2	< 0.1%
54	1	< 0.1%
55	1	< 0.1%
56	10	0.1%
57	22	0.2%
58	46	0.4%

Value	Count	Frequency (%)
81	2	< 0.1%
80	6	0.1%
79	5	< 0.1%
78	22	0.2%
77	41	0.3%
76	110	0.9%
75	160	1.3%
74	271	2.3%
73	399	3.3%
72	817	6.8%

wtkg3
Real number (ℝ)

Distinct	286
Distinct (%)	2.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8181.474

Minimum	2268
Maximum	22906
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	93.4 KiB

Quantile statistics

Minimum	2268
5-th percentile	5443
Q1	6804
median	7938
Q3	9072
95-th percentile	11793
Maximum	22906
Range	20638
Interquartile range (IQR)	2268

Descriptive statistics

Standard deviation	2000.1837
Coefficient of variation (CV)	0.24447718
Kurtosis	2.57045
Mean	8181.474
Median Absolute Deviation (MAD)	1134
Skewness	1.0766844
Sum	97629529
Variance	4000734.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7938	1092	9.2%
8165	564	4.7%
9072	535	4.5%
6804	514	4.3%
7257	493	4.1%
7711	436	3.7%
6350	376	3.2%
8618	369	3.1%
7484	303	2.5%
5897	292	2.4%
Other values (276)	6959	58.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2268	1	< 0.1%
2313	1	< 0.1%
2722	1	< 0.1%
3175	3	< 0.1%
3402	1	< 0.1%
3493	1	< 0.1%
3629	2	< 0.1%
3856	6	0.1%
3901	1	< 0.1%
3946	1	< 0.1%

Value	Count	Frequency (%)
22906	1	< 0.1%
22816	1	< 0.1%
20412	1	< 0.1%
19958	2	< 0.1%
19504	1	< 0.1%
19278	1	< 0.1%
19187	1	< 0.1%
18824	1	< 0.1%
18688	1	< 0.1%
18597	1	< 0.1%

x.bmi5
Real number (ℝ)

Distinct	1496
Distinct (%)	12.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2799.0185

Minimum	1331
Maximum	5052
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	93.4 KiB

Quantile statistics

Minimum	1331
5-th percentile	2022
Q1	2428
median	2726
Q3	3072
95-th percentile	3897
Maximum	5052
Range	3721
Interquartile range (IQR)	644

Descriptive statistics

Standard deviation	563.41019
Coefficient of variation (CV)	0.20128848
Kurtosis	1.2997788
Mean	2799.0185
Median Absolute Deviation (MAD)	317
Skewness	0.94664942
Sum	33400688
Variance	317431.04
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2726	1079	9.0%
2663	123	1.0%
2744	92	0.8%
2441	91	0.8%
2712	82	0.7%
2746	79	0.7%
2510	78	0.7%
2929	77	0.6%
2834	72	0.6%
2421	64	0.5%
Other values (1486)	10096	84.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1331	1	< 0.1%
1356	1	< 0.1%
1364	1	< 0.1%
1367	1	< 0.1%
1406	1	< 0.1%
1414	1	< 0.1%
1459	1	< 0.1%
1469	1	< 0.1%
1477	2	< 0.1%
1492	1	< 0.1%

Value	Count	Frequency (%)
5052	2	< 0.1%
5049	1	< 0.1%
5048	1	< 0.1%
5040	1	< 0.1%
5021	2	< 0.1%
5012	1	< 0.1%
4995	1	< 0.1%
4992	4	< 0.1%
4989	1	< 0.1%
4980	1	< 0.1%

htm4
Real number (ℝ)

Distinct	47
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	170.02866

Minimum	122
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	93.4 KiB

Quantile statistics

Minimum	122
5-th percentile	155
Q1	163
median	170
Q3	178
95-th percentile	188
Maximum	206
Range	84
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	10.29852
Coefficient of variation (CV)	0.06056932
Kurtosis	-0.16192213
Mean	170.02866
Median Absolute Deviation (MAD)	7
Skewness	0.055583848
Sum	2028952
Variance	106.05952
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
170	1399	11.7%
168	1052	8.8%
163	969	8.1%
165	923	7.7%
173	913	7.7%
160	852	7.1%
183	817	6.8%
178	799	6.7%
175	787	6.6%
157	727	6.1%
Other values (37)	2695	22.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
122	5	< 0.1%
124	1	< 0.1%
127	2	< 0.1%
130	2	< 0.1%
135	2	< 0.1%
137	1	< 0.1%
140	3	< 0.1%
142	10	0.1%
145	22	0.2%
147	46	0.4%

Value	Count	Frequency (%)
206	2	< 0.1%
205	1	< 0.1%
203	6	0.1%
201	5	< 0.1%
198	22	0.2%
196	41	0.3%
193	110	0.9%
191	160	1.3%
188	271	2.3%
185	399	3.3%

x.drnkwek
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	104
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6358.6454

Minimum	0
Maximum	99900
Zeros	5546
Zeros (%)	46.5%
Negative	0
Negative (%)	0.0%
Memory size	93.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	23
Q3	400
95-th percentile	99900
Maximum	99900
Range	99900
Interquartile range (IQR)	400

Descriptive statistics

Standard deviation	23843.214
Coefficient of variation (CV)	3.7497317
Kurtosis	11.444856
Mean	6358.6454
Median Absolute Deviation (MAD)	23
Skewness	3.6640616
Sum	75877715
Variance	5.6849887 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5546	46.5%
99900	727	6.1%
23	624	5.2%
47	480	4.0%
700	321	2.7%
93	313	2.6%
200	251	2.1%
100	239	2.0%
140	225	1.9%
1400	224	1.9%
Other values (94)	2983	25.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5546	46.5%
23	624	5.2%
47	480	4.0%
70	209	1.8%
93	313	2.6%
100	239	2.0%
117	131	1.1%
140	225	1.9%
163	30	0.3%
187	140	1.2%

Value	Count	Frequency (%)
99900	727	6.1%
42000	1	< 0.1%
26600	1	< 0.1%
21000	3	< 0.1%
19600	1	< 0.1%
15400	1	< 0.1%
14700	1	< 0.1%
14000	1	< 0.1%
10500	1	< 0.1%
9000	1	< 0.1%

drocdy3.
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	34
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	59.394369

Minimum	0
Maximum	900
Zeros	5546
Zeros (%)	46.5%
Negative	0
Negative (%)	0.0%
Memory size	93.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	3
Q3	29
95-th percentile	100
Maximum	900
Range	900
Interquartile range (IQR)	29

Descriptive statistics

Standard deviation	191.74502
Coefficient of variation (CV)	3.2283368
Kurtosis	14.938127
Mean	59.394369
Median Absolute Deviation (MAD)	3
Skewness	4.070848
Sum	708753
Variance	36766.154
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=34)

Value	Count	Frequency (%)
0	5546	46.5%
3	901	7.6%
7	646	5.4%
100	616	5.2%
900	579	4.9%
14	471	3.9%
29	435	3.6%
10	361	3.0%
17	311	2.6%
13	307	2.6%
Other values (24)	1760	14.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5546	46.5%
3	901	7.6%
7	646	5.4%
10	361	3.0%
13	307	2.6%
14	471	3.9%
17	311	2.6%
20	139	1.2%
23	79	0.7%
27	80	0.7%

Value	Count	Frequency (%)
900	579	4.9%
100	616	5.2%
97	14	0.1%
93	27	0.2%
90	6	0.1%
87	5	< 0.1%
86	39	0.3%
83	78	0.7%
80	8	0.1%
77	1	< 0.1%

x.llcpwt2
Real number (ℝ)

Distinct	4090
Distinct (%)	34.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	598.49875

Minimum	5.074045
Maximum	18975.737
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	93.4 KiB

Quantile statistics

Minimum	5.074045
5-th percentile	31.393872
Q1	133.65209
median	306.53051
Q3	698.66744
95-th percentile	2105.6394
Maximum	18975.737
Range	18970.663
Interquartile range (IQR)	565.01535

Descriptive statistics

Standard deviation	916.07612
Coefficient of variation (CV)	1.5306233
Kurtosis	59.006036
Mean	598.49875
Median Absolute Deviation (MAD)	218.41357
Skewness	5.6192901
Sum	7141885.6
Variance	839195.46
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
202.854322	103	0.9%
347.364408	101	0.8%
591.664273	87	0.7%
633.838616	71	0.6%
200.956964	58	0.5%
731.932005	57	0.5%
188.201511	50	0.4%
362.747245	49	0.4%
191.502356	47	0.4%
344.115404	45	0.4%
Other values (4080)	11265	94.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
5.074045	1	< 0.1%
5.726045	1	< 0.1%
8.265919	1	< 0.1%
8.554491	1	< 0.1%
8.849872	1	< 0.1%
9.104332	3	< 0.1%
9.394153	1	< 0.1%
9.444705	2	< 0.1%
9.535264	2	< 0.1%
10.466459	1	< 0.1%

Value	Count	Frequency (%)
18975.73716	1	< 0.1%
16755.01932	1	< 0.1%
15796.41843	1	< 0.1%
14916.48982	1	< 0.1%
13139.4659	1	< 0.1%
11053.15498	9	0.1%
10511.79421	1	< 0.1%
9091.844086	1	< 0.1%
9009.12549	1	< 0.1%
8573.237046	1	< 0.1%

x.llcpwt
Real number (ℝ)

Distinct	11577
Distinct (%)	97.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	602.64065

Minimum	1.586053
Maximum	33255.885
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	93.4 KiB

Quantile statistics

Minimum	1.586053
5-th percentile	21.727396
Q1	101.63766
median	260.04018
Q3	642.13848
95-th percentile	2234.7532
Maximum	33255.885
Range	33254.299
Interquartile range (IQR)	540.50081

Descriptive statistics

Standard deviation	1181.6498
Coefficient of variation (CV)	1.9607868
Kurtosis	146.29024
Mean	602.64065
Median Absolute Deviation (MAD)	196.44607
Skewness	8.856367
Sum	7191310.8
Variance	1396296.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
158.421033	6	0.1%
1380.134792	4	< 0.1%
154.052055	4	< 0.1%
93.237602	4	< 0.1%
138.340573	4	< 0.1%
220.766315	4	< 0.1%
115.316004	3	< 0.1%
253.804637	3	< 0.1%
201.283039	3	< 0.1%
289.802479	3	< 0.1%
Other values (11567)	11895	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.586053	1	< 0.1%
2.284604	1	< 0.1%
2.359978	1	< 0.1%
3.317255	1	< 0.1%
3.323902	1	< 0.1%
3.526036	1	< 0.1%
3.644764	1	< 0.1%
3.709969	1	< 0.1%
3.875079	1	< 0.1%
4.04181	1	< 0.1%

Value	Count	Frequency (%)
33255.88526	1	< 0.1%
30965.05685	1	< 0.1%
24090.36806	1	< 0.1%
22041.02045	1	< 0.1%
18910.35025	1	< 0.1%
18356.25929	1	< 0.1%
17154.36917	1	< 0.1%
16439.74002	1	< 0.1%
15295.79068	1	< 0.1%
14719.41168	1	< 0.1%

x.wt2rake
Real number (ℝ)

Distinct	2325
Distinct (%)	19.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	80.385246

Minimum	0.213384
Maximum	2859.4004
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	93.4 KiB

Quantile statistics

Minimum	0.213384
5-th percentile	3.958867
Q1	18.083807
median	46.653717
Q3	89.453108
95-th percentile	294.61334
Maximum	2859.4004
Range	2859.1871
Interquartile range (IQR)	71.369301

Descriptive statistics

Standard deviation	134.46228
Coefficient of variation (CV)	1.6727234
Kurtosis	165.77606
Mean	80.385246
Median Absolute Deviation (MAD)	30.394465
Skewness	9.6060005
Sum	959237.14
Variance	18080.105
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
56.130293	189	1.6%
105.574086	165	1.4%
27.244899	161	1.3%
51.13805	153	1.3%
46.653717	146	1.2%
73.787482	122	1.0%
184.630736	117	1.0%
28.370357	83	0.7%
76.646341	80	0.7%
22.727823	75	0.6%
Other values (2315)	10642	89.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.213384	1	< 0.1%
0.370099	1	< 0.1%
0.387597	5	< 0.1%
0.426768	3	< 0.1%
0.458301	2	< 0.1%
0.463648	14	0.1%
0.51399	2	< 0.1%
0.574508	1	< 0.1%
0.638595	2	< 0.1%
0.667206	2	< 0.1%

Value	Count	Frequency (%)
2859.400441	10	0.1%
2134.405202	1	< 0.1%
1465.724872	1	< 0.1%
1422.936801	1	< 0.1%
1362.475538	1	< 0.1%
1272.341332	4	< 0.1%
1150.965155	2	< 0.1%
1078.452871	1	< 0.1%
1043.797253	2	< 0.1%
985.571176	1	< 0.1%

x.ststr
Real number (ℝ)

Distinct	1376
Distinct (%)	11.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	299280.47

Minimum	11011
Maximum	722019
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	93.4 KiB

Quantile statistics

Minimum	11011
5-th percentile	52059
Q1	181101
median	292019
Q3	421042
95-th percentile	532119
Maximum	722019
Range	711008
Interquartile range (IQR)	239941

Descriptive statistics

Standard deviation	157196.86
Coefficient of variation (CV)	0.52524932
Kurtosis	-0.69773692
Mean	299280.47
Median Absolute Deviation (MAD)	120000
Skewness	0.13827334
Sum	3.5713138 × 10⁹
Variance	2.4710854 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
132019	189	1.6%
362019	165	1.4%
272059	161	1.3%
412019	153	1.3%
272049	146	1.2%
242019	122	1.0%
241011	119	1.0%
722019	117	1.0%
152019	83	0.7%
271051	82	0.7%
Other values (1366)	10596	88.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
11011	7	0.1%
11012	2	< 0.1%
11021	8	0.1%
11022	2	< 0.1%
11031	5	< 0.1%
11032	1	< 0.1%
11041	3	< 0.1%
11051	8	0.1%
11061	2	< 0.1%
11071	7	0.1%

Value	Count	Frequency (%)
722019	117	1.0%
721081	1	< 0.1%
721071	2	< 0.1%
721061	4	< 0.1%
721051	1	< 0.1%
721041	6	0.1%
721021	2	< 0.1%
721011	2	< 0.1%
662019	17	0.1%
661011	36	0.3%

x.strwt
Real number (ℝ)

Distinct	1376
Distinct (%)	11.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	72.431925

Minimum	0.387597
Maximum	2859.4004
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	93.4 KiB

Quantile statistics

Minimum	0.387597
5-th percentile	3.136146
Q1	15.393544
median	37.187633
Q3	76.646341
95-th percentile	283.26489
Maximum	2859.4004
Range	2859.0128
Interquartile range (IQR)	61.252797

Descriptive statistics

Standard deviation	126.99416
Coefficient of variation (CV)	1.7532898
Kurtosis	201.21084
Mean	72.431925
Median Absolute Deviation (MAD)	27.49329
Skewness	10.594005
Sum	864330.16
Variance	16127.516
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
56.130293	189	1.6%
105.574086	165	1.4%
27.244899	161	1.3%
51.13805	153	1.3%
46.653717	146	1.2%
73.787482	122	1.0%
13.906822	119	1.0%
184.630736	117	1.0%
28.370357	83	0.7%
24.495533	82	0.7%
Other values (1366)	10596	88.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.387597	5	< 0.1%
0.426768	8	0.1%
0.458301	2	< 0.1%
0.463648	21	0.2%
0.51399	2	< 0.1%
0.574508	3	< 0.1%
0.638595	2	< 0.1%
0.667206	6	0.1%
0.740199	26	0.2%
0.757947	3	< 0.1%

Value	Count	Frequency (%)
2859.400441	10	0.1%
1272.341332	4	< 0.1%
1150.965155	2	< 0.1%
1043.797253	2	< 0.1%
985.571176	1	< 0.1%
940.440531	10	0.1%
901.203375	2	< 0.1%
871.292497	2	< 0.1%
754.443252	7	0.1%
711.468401	3	< 0.1%

x.rawrake
Real number (ℝ)

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.2591553

Minimum	0.333333
Maximum	5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	93.4 KiB

Quantile statistics

Minimum	0.333333
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	2
Maximum	5
Range	4.666667
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.58616842
Coefficient of variation (CV)	0.46552513
Kurtosis	8.2585806
Mean	1.2591553
Median Absolute Deviation (MAD)	0
Skewness	2.5837491
Sum	15025.5
Variance	0.34359342
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
1	9227	77.3%
2	2035	17.1%
3	339	2.8%
0.5	119	1.0%
4	109	0.9%
0.666667	46	0.4%
5	30	0.3%
1.5	13	0.1%
0.333333	8	0.1%
1.333333	3	< 0.1%
Other values (2)	4	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.333333	8	0.1%
0.5	119	1.0%
0.666667	46	0.4%
1	9227	77.3%
1.333333	3	< 0.1%
1.5	13	0.1%
1.666667	1	< 0.1%
2	2035	17.1%
2.5	3	< 0.1%
3	339	2.8%

Value	Count	Frequency (%)
5	30	0.3%
4	109	0.9%
3	339	2.8%
2.5	3	< 0.1%
2	2035	17.1%
1.666667	1	< 0.1%
1.5	13	0.1%
1.333333	3	< 0.1%
1	9227	77.3%
0.666667	46	0.4%

Auto

The auto setting is an interpretable pairwise column metric of the following mapping:

Variable_type-Variable_type : Method, Range
Categorical-Categorical : Cramer's V, [0,1]
Numerical-Categorical : Cramer's V, [0,1] (using a discretized numerical column)
Numerical-Numerical : Spearman's ρ, [-1,1]

The number of bins used in the discretization for the Numerical-Categorical column pair can be changed using config.correlations["auto"].n_bins. The number of bins affects the granularity of the association you wish to measure.

This configuration uses the recommended metric for each pair of columns.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	weight2	height3	children	alcday5	x.psu	physhlth	menthlth	sleptim1	htin4	wtkg3	x.bmi5	htm4	x.drnkwek	drocdy3.	x.llcpwt2	x.llcpwt	x.wt2rake	x.ststr	x.strwt	x.rawrake
0	138.0	504.0	2.0	203.0	2018012727	88	88	8	64.0	6260.0	2369.0	163.0	140	10	347.364408	300.334407	46.653717	272049	46.653717	1.0
1	240.0	507.0	88.0	203.0	2018003318	30	30	7	72.0	10886.0	3255.0	183.0	420	10	591.664273	230.240437	184.630736	722019	184.630736	1.0
2	120.0	504.0	88.0	888.0	2018014634	88	88	6	64.0	5443.0	2060.0	163.0	0	0	142.637597	234.853526	37.261383	312199	37.261383	1.0
3	133.0	502.0	88.0	888.0	2018004927	88	88	7	62.0	6033.0	2433.0	157.0	0	0	131.943500	95.944181	18.271132	451101	18.271132	1.0
4	170.0	505.0	88.0	105.0	2018005584	88	88	7	65.0	7711.0	2829.0	165.0	500	71	155.667313	87.722689	13.906822	241011	13.906822	1.0
5	192.0	507.0	88.0	104.0	2018002181	88	88	7	73.0	8709.0	2533.0	185.0	1200	57	96.390993	82.128034	28.185579	191011	28.185579	1.0
6	205.0	511.0	88.0	202.0	2018005077	99	99	8	71.0	9299.0	2859.0	180.0	47	7	1232.720826	4104.860898	207.983856	12049	207.983856	1.0
7	220.0	508.0	88.0	888.0	2018001754	88	30	6	68.0	9979.0	3345.0	173.0	0	0	737.707176	1650.567662	81.876778	511041	40.938389	2.0
8	200.0	507.0	2.0	202.0	2018003682	88	88	7	73.0	9072.0	2639.0	185.0	47	7	645.890548	972.506855	127.293033	552089	127.293033	1.0
9	200.0	507.0	88.0	777.0	2018010633	88	88	7	67.0	9072.0	3132.0	170.0	99900	900	765.831083	445.980369	43.048300	482099	43.048300	1.0

	weight2	height3	children	alcday5	x.psu	physhlth	menthlth	sleptim1	htin4	wtkg3	x.bmi5	htm4	x.drnkwek	drocdy3.	x.llcpwt2	x.llcpwt	x.wt2rake	x.ststr	x.strwt	x.rawrake
11923	175.0	507.0	1.0	102.0	2018011812	2	88	8	67.0	7938.0	2741.0	170.0	400	29	161.234830	236.677733	17.408657	122019	17.408657	1.0
11924	140.0	507.0	88.0	888.0	2018001112	88	88	8	67.0	6350.0	2193.0	170.0	0	0	51.830631	49.519355	6.496839	311091	6.496839	1.0
11925	183.0	507.0	88.0	777.0	2018003298	88	88	6	73.0	8301.0	2414.0	185.0	99900	900	305.178735	418.970425	45.945026	42099	45.945026	1.0
11926	140.0	503.0	88.0	888.0	2018000119	88	88	7	63.0	6350.0	2480.0	160.0	0	0	581.030702	150.861582	90.788494	61031	90.788494	1.0
11927	160.0	500.0	88.0	888.0	2018000626	30	88	9	60.0	7257.0	3125.0	152.0	0	0	63.512846	76.683864	7.383162	441011	7.383162	1.0
11928	250.0	511.0	1.0	107.0	2018003393	88	88	8	71.0	11340.0	3487.0	180.0	2100	100	551.939252	674.656860	51.138050	412019	51.138050	1.0
11929	215.0	510.0	88.0	888.0	2018005797	30	88	8	70.0	9752.0	3085.0	178.0	0	0	65.027460	98.935261	5.687222	241021	5.687222	1.0
11930	160.0	508.0	88.0	888.0	2018003470	88	88	7	68.0	7257.0	2433.0	173.0	0	0	93.619977	77.027603	4.486657	102019	4.486657	1.0
11931	220.0	505.0	88.0	201.0	2018003951	88	88	8	65.0	9979.0	3661.0	165.0	23	3	175.165147	88.663009	28.192596	442019	28.192596	1.0
11932	240.0	508.0	88.0	210.0	2018004529	1	2	7	68.0	10886.0	3649.0	173.0	467	33	403.740658	341.825532	58.187758	542019	58.187758	1.0

Overview

Variables

Interactions

Correlations

Auto

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample